Used when copying data from a record in one module to a record in another module using the Transmit menu option: specifies a mapping where the name of the From column is different to the name of the To column.
DescriptionThis entry is used when using the Transmit menu option to copy data from a record in one module (e.g. Birth Notices) to a record in another module (e.g. StillBirths) where the From and To columns have different names.
Note: See also Transmit Skip Registry entry.
Usage
This Registry entry can be assigned to users and groups:
| Key | User | Group | Group |
|---|---|---|---|
| Key 1 | User | Group | Group |
| Key 2 | user | group | Default |
| Key 3 | Table | ||
| Key 4 | From table | ||
| Key 5 | To table | ||
| Key 6 | Transmit Map | ||
| Value | From column=To column;... | ||
In pipe-delimited format:User | user | Table | From table | To table | Transmit Map | From column=To column;... |
Group | group | Table | From table | To table | Transmit Map | From column=To column;... |
Group | Default | Table | From table | To table | Transmit Map | From column=To column;... |
where:
From table | is the source table: data is copied from this table. |
To table | is the destination table: data is copied to this table. |
From column=To column;... | is a semicolon separated list of column pairs with different names; data in the From column will be copied to the To column. |
Example
This entry ensures that when the Transmit menu option is selected in the Birth Notices module, data in the From columns is copied to the differently named To columns in the Still Births module:
| Key | Setting |
|---|---|
| Key 1 | Group |
| Key 2 | Default |
| Key 3 | Table |
| Key 4 | ebirthnotices |
| Key 5 | estillbirths |
| Key 6 | Transmit Map |
| Value | MotherStreetAddressOfResidence=MotherResidenceAddress; MotherCityTownOfResidence=MotherResidenceCityTown; MotherStateOfResidence=MotherResidenceProvince; ChildDateOfBirth=FetusDateOfDelivery; ChildTimeOfBirth=FetusTimeOfDelivery |